﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace DeltaFlex.Negoci
{
    public static class ConsTaules
    {
        #region Usuari
        public class Usuari
        {
            public const string NOM_TAULA = "USUARI";

            public const string COLUMNA_IDUSUARI = "IDUSUARI";
            public const string COLUMNA_LOGINUSUARI = "LOGINUSUARI";
            public const string COLUMNA_PASSWORDUSUARI = "PASSWORDUSUARI";
            public const string COLUMNA_DNIUSUARI = "DNIUSUARI";
            public const string COLUMNA_DATAALTAUSUARI = "DATAALTAUSUARI";
            public const string COLUMNA_DATADARRERACCES = "DATADARRERACCES";
            public const string COLUMNA_OBSERVACIONSUSU = "OBSERVACIONSUSU";
            public const string COLUMNA_ROLUSUARI = "ROLUSUARI";
        }
        #endregion

        #region Ordre
        public class Ordre_Treball
        {
            public const string NOM_TAULA = "ORDRE_TREBALL";

            public const string COLUMNA_IDORDRE = "IDORDRE";
            public const string COLUMNA_IDCLIENT = "IDCLIENT";
            public const string COLUMNA_IDIMPRESOR = "IDIMPRESOR";
            public const string COLUMNA_DATAENTREGA = "DATAENTREGA";
            public const string COLUMNA_HORAENTREGA = "HORAENTREGA";
            public const string COLUMNA_REFERENCIACLIENT = "REFERENCIACLIENT";
            public const string COLUMNA_IDTREBALL = "IDTREBALL";
            public const string COLUMNA_PEDIDOCLIENT = "PEDIDOCLIENT";
            public const string COLUMNA_TIPOTREBALL = "TIPOTREBALL";
            public const string COLUMNA_TIPOCAIXA = "TIPOCAIXA";
            public const string COLUMNA_FITXA = "FITXA";
            public const string COLUMNA_TIPOMESURES = "TIPOMESURES";
            public const string COLUMNA_MESURES = "MESURES";
            public const string COLUMNA_NUMTROQUEL = "NUMTROQUEL";
            public const string COLUMNA_POSES = "POSES";
            public const string COLUMNA_MATERIALADJUNT = "MATERIALADJUNT";
            public const string COLUMNA_MATERIALTORNAR = "MATERIALTORNAR";
            public const string COLUMNA_COLORS = "COLORS";
            public const string COLUMNA_TIPOCLITXE = "TIPOCLITXE";
            public const string COLUMNA_IDMAQUINA = "IDMAQUINA";
            public const string COLUMNA_DEFLACCIO = "DEFLACCIO";
            public const string COLUMNA_FEINAFER = "FEINAFER";
            public const string COLUMNA_OBSERVACIONS = "OBSERVACIONS";
            public const string COLUMNA_NOMARXIU = "NOMARXIU";
            
        }
        #endregion

        #region Client
        public class Client
        {
            public const string NOM_TAULA = "CLIENT";

            public const string COLUMNA_IDCLIENT = "IDCLIENT";
            public const string COLUMNA_NOMCLIENT = "NOMCLIENT";
            public const string COLUMNA_NIFCLIENT = "NIFCLIENT";
            public const string COLUMNA_IDADREÇACLIENT = "IDADREÇACLIENT";
            public const string COLUMNA_TELEFONCLIENT = "TELEFONCLIENT";
            public const string COLUMNA_FAXCLIENT = "FAXCLIENT";
            public const string COLUMNA_EMAIL = "EMAIL";
            public const string COLUMNA_NUMCOMPTE = "NUMCOMPTE";
            public const string COLUMNA_FORMAPAGO = "FORMAPAGO";

            public const string COLUMNA_CARRERNUMERO = "CARRERNUMERO";
            public const string COLUMNA_POLIGON = "POLIGON";
            public const string COLUMNA_CIUTAT = "CIUTAT";
            public const string COLUMNA_CODIPOSTAL = "CODIPOSTAL";
            public const string COLUMNA_PROVINCIA = "PROVINCIA";
            public const string COLUMNA_PAIS = "PAIS";
        }

        public class AdreçaClient
        {
            public const string NOM_TAULA = "ADREÇA_CLIENT";

            public const string COLUMNA_IDADREÇACLIENT = "IDADREÇACLIENT";
            public const string COLUMNA_CARRERNUMERO = "CARRERNUMERO";
            public const string COLUMNA_POLIGON = "POLIGON";
            public const string COLUMNA_CIUTAT = "CIUTAT";
            public const string COLUMNA_CODIPOSTAL = "CODIPOSTAL";
            public const string COLUMNA_PROVINCIA = "PROVINCIA";
            public const string COLUMNA_PAIS = "PAIS";
        }
        #endregion

        #region Preus
        public class Preus
        {
            public const string NOM_TAULA = "PREUS";

            public const string COLUMNA_IDPREU = "IDPREU";
            public const string COLUMNA_PREU = "PREU";
            public const string COLUMNA_DESCPREU = "DESCPREU";
        }
        #endregion

        #region Client Producte Preu
        public class ClientArticlePreu
        {
            public const string NOM_TAULA = "CLIENT_ARTICLE_PREU";

            public const string COLUMNA_IDCLIENT = "IDCLIENT";
            public const string COLUMNA_IDARTICLE = "IDARTICLE";
            public const string COLUMNA_PREU = "PREU";
        }
        #endregion

        #region Descomptes
        public class Descomptes
        {
            public const string NOM_TAULA = "DESCOMPTES";

            public const string COLUMNA_IDDESCOMPTE = "IDDESCOMPTE";
            public const string COLUMNA_DESCOMPTE = "DESCOMPTE";
            public const string COLUMNA_DESCDESCOMPTE = "DESCDESCOMPTE";
        }
        #endregion

        #region Maquina Cartoner
        public class MaquinaCartoner
        {
            public const string NOM_TAULA = "MAQUINACARTONER";

            public const string COLUMNA_IDMAQUINACARTONER = "IDMAQUINACARTONER";
            public const string COLUMNA_IDCLIENTIMPRESOR = "IDCLIENTIMPRESOR";
            public const string COLUMNA_NOMMAQUINA = "NOMMAQUINA";
            public const string COLUMNA_DEFLACCIOMAQUINA = "DEFLACCIOMAQUINA";
            public const string COLUMNA_CALIBREMAQUINA = "CALIBREMAQUINA";
            public const string COLUMNA_URLFITXAMAQUINA = "URLFITXAMAQUINA";
        }
        #endregion

        #region Tipus Caixa
        public class TipusCaixa
        {
            public const string NOM_TAULA = "TIPUS_CAIXA";

            public const string COLUMNA_IDTIPUSCAIXA = "IDTIPUSCAIXA";
            public const string COLUMNA_NOMTIPUSCAIXA = "NOMTIPUSCAIXA";
        }
        #endregion

        #region Tipus Treball
        public class Treball
        {
            public const string NOM_TAULA = "TIPUS_TREBALL";

            public const string COLUMNA_IDTREBALL = "IDTREBALL";
            public const string COLUMNA_NOMTIPUSTREBALL = "NOMTIPUSTREBALL";
        }
        #endregion

        #region Articles
        public class Articles
        {
            public const string NOM_TAULA = "ARTICLES";

            public const string COLUMNA_IDARTICLE = "IDARTICLE";
            public const string COLUMNA_REFERENCIAARTICLE = "REFERENCIAARTICLE";
            public const string COLUMNA_NOMARTICLE = "NOMARTICLE";
            public const string COLUMNA_UNITAT = "UNITAT";
            public const string COLUMNA_PVP = "PVP";
        }
        #endregion

        #region Concepte

        public class Concepte_OT
        {
            public const string NOM_TAULA = "CONCEPTE_OT";

            public const string COLUMNA_IDCONCEPTE = "IDCONCEPTE";
            public const string COLUMNA_IDORDRE = "IDORDRE";
            public const string COLUMNA_QUANTITAT = "QUANTITAT";
            public const string COLUMNA_ALT = "ALT";
            public const string COLUMNA_AMPLE = "AMPLE";
            public const string COLUMNA_IMPORT = "IMPORT";

        }

        public class Concepte_Albara
        {
            public const string NOM_TAULA = "CONCEPTE_ALBARA";

            public const string COLUMNA_IDCONCEPTE_ALBARA = "IDCONCEPTE_ALBARA";
            public const string COLUMNA_IDALBARA = "IDALBARA";
            public const string COLUMNA_IDARTICLE = "IDARTICLE";
            public const string COLUMNA_QUANTITAT = "QUANTITAT";
            public const string COLUMNA_STRSUPERFICIE = "STRSUPERFICIE";
            public const string COLUMNA_DECIMALSUPERFICIE = "DECIMALSUPERFICIE";
            public const string COLUMNA_UNITATS = "UNITATS";
            public const string COLUMNA_PVP = "PVP";
            public const string COLUMNA_IMPORT = "IMPORT";
        }

        public class Concepte_Factura
        {
            public const string NOM_TAULA = "CONCEPTE_FACTURA";

            public const string COLUMNA_IDCONCEPTE_FACTURA = "IDCONCEPTE_FACTURA";
            public const string COLUMNA_IDFACTURA="IDFACTURA";
            public const string COLUMNA_IDALBARA="IDALBARA";
        }
        #endregion

        #region Albara
        public class Albara
        {
            public const string NOM_TAULA = "ALBARA";

            public const string COLUMNA_IDALBARA = "IDALBARA";
            public const string COLUMNA_IDORDRE_TREBALL = "IDORDRE_TREBALL";
            public const string COLUMNA_IDCLIENT = "IDCLIENT";
            public const string COLUMNA_DATA = "DATA";
            public const string COLUMNA_TOTAL = "TOTAL";
        }
        
        #endregion

        #region Factura
        public class Factura
        {
            public const string NOM_TAULA = "FACTURA";
            public const string COLUMNA_IDFACTURA = "IDFACTURA";
            public const string COLUMNA_IDCLIENT = "IDCLIENT";
            public const string COLUMNA_DATA = "DATA";
            public const string COLUMNA_VENCIMENT = "VENCIMENT";
            public const string COLUMNA_TOTAL = "TOTAL";

        }
        #endregion
    }
}


